encounterresults
Table: encounterresults
The encounterresults table stores the results or observations collected during encounters between participants.
It records values, display information, and grouping details for each encounter element.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| element | varchar(255) | NOT NULL | Name or identifier of the encounter element being recorded |
| encounterId | int(11) | NOT NULL | Identifier of the encounter (links to encounter) |
| p1id | int(11) | NOT NULL | Participant 1 ID (links to idmapper) |
| p2id | int(11) | NOT NULL | Participant 2 ID (links to idmapper) |
| value | varchar(255) | NULL | Recorded value for the element during the encounter |
| orderAs | int(11) | NULL | Ordering number for display purposes |
| groupName | varchar(255) | NULL | Group name or category for the element |
| displayName | varchar(255) | NULL | Friendly display name for the element |
Indexes
- None specified
Foreign Key Relations
- None defined in the table, but
encounterId,p1id, andp2idcorrespond to theencountertable andidmappertable for participants.
Usage Notes
- Stores detailed results or observations collected during encounters.
groupNameanddisplayNamehelp organize and display results in reports or forms.orderAscan be used to define the display sequence of elements.- Linked indirectly to
encounterandidmapperto maintain participant context.